Dataset statistics
| Number of variables | 17 |
|---|---|
| Number of observations | 120 |
| Missing cells | 166 |
| Missing cells (%) | 8.1% |
| Duplicate rows | 4 |
| Duplicate rows (%) | 3.3% |
| Total size in memory | 16.1 KiB |
| Average record size in memory | 137.1 B |
Variable types
| NUM | 16 |
|---|---|
| DATE | 1 |
| Dataset has 4 (3.3%) duplicate rows | Duplicates |
RDPI is highly correlated with Years and 1 other fields | High correlation |
Years is highly correlated with RDPI and 1 other fields | High correlation |
Pop is highly correlated with Years and 1 other fields | High correlation |
Wings_P is highly correlated with Comm FS Wing Price | High correlation |
Comm FS Wing Price is highly correlated with Wings_P | High correlation |
Years has 70 (58.3%) missing values | Missing |
Time Series has 6 (5.0%) missing values | Missing |
RDPI has 7 (5.8%) missing values | Missing |
Retail Fresh Wing Sales has 6 (5.0%) missing values | Missing |
Retail Fresh Wing Price has 6 (5.0%) missing values | Missing |
Comm FS Wing Sales has 6 (5.0%) missing values | Missing |
Comm FS Wing Price has 6 (5.0%) missing values | Missing |
FS Nuggets Servings has 6 (5.0%) missing values | Missing |
Unemployment has 6 (5.0%) missing values | Missing |
Traffic has 6 (5.0%) missing values | Missing |
Pop has 7 (5.8%) missing values | Missing |
Wings_P has 5 (4.2%) missing values | Missing |
Operator Count has 6 (5.0%) missing values | Missing |
Wing Servings has 6 (5.0%) missing values | Missing |
Retail Store Count has 6 (5.0%) missing values | Missing |
Retail Wing Promotion has 6 (5.0%) missing values | Missing |
Wing Inventory has 5 (4.2%) missing values | Missing |
Time Series is uniformly distributed | Uniform |
Reproduction
| Analysis started | 2020-11-04 18:59:20.861530 |
|---|---|
| Analysis finished | 2020-11-04 19:00:36.609132 |
| Duration | 1 minute and 15.75 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 10 |
|---|---|
| Distinct (%) | 20.0% |
| Missing | 70 |
| Missing (%) | 58.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2015.5 |
|---|---|
| Minimum | 2011 |
| Maximum | 2020 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 960.0 B |
Quantile statistics
| Minimum | 2011 |
|---|---|
| 5-th percentile | 2011 |
| Q1 | 2013 |
| median | 2015.5 |
| Q3 | 2018 |
| 95-th percentile | 2020 |
| Maximum | 2020 |
| Range | 9 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 2.901442287 |
|---|---|
| Coefficient of variation (CV) | 0.001439564519 |
| Kurtosis | -1.225789813 |
| Mean | 2015.5 |
| Median Absolute Deviation (MAD) | 2.5 |
| Skewness | 0 |
| Sum | 100775 |
| Variance | 8.418367347 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 2017 | 5 | 4.2% | |
| 2015 | 5 | 4.2% | |
| 2013 | 5 | 4.2% | |
| 2020 | 5 | 4.2% | |
| 2019 | 5 | 4.2% | |
| 2018 | 5 | 4.2% | |
| 2016 | 5 | 4.2% | |
| 2014 | 5 | 4.2% | |
| 2012 | 5 | 4.2% | |
| 2011 | 5 | 4.2% | |
| (Missing) | 70 | 58.3% |
| Value | Count | Frequency (%) | |
| 2011 | 5 | 4.2% | |
| 2012 | 5 | 4.2% | |
| 2013 | 5 | 4.2% | |
| 2014 | 5 | 4.2% | |
| 2015 | 5 | 4.2% |
| Value | Count | Frequency (%) | |
| 2020 | 5 | 4.2% | |
| 2019 | 5 | 4.2% | |
| 2018 | 5 | 4.2% | |
| 2017 | 5 | 4.2% | |
| 2016 | 5 | 4.2% |
| Distinct | 114 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 6 |
| Missing (%) | 5.0% |
| Memory size | 960.0 B |
| Minimum | 2011-01-01 00:00:00 |
|---|---|
| Maximum | 2020-06-01 00:00:00 |
Histogram with fixed size bins (bins=50)
| Distinct | 112 |
|---|---|
| Distinct (%) | 99.1% |
| Missing | 7 |
| Missing (%) | 5.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41896.69027 |
|---|---|
| Minimum | 38610 |
| Maximum | 51550 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 960.0 B |
Quantile statistics
| Minimum | 38610 |
|---|---|
| 5-th percentile | 38725.2 |
| Q1 | 39483 |
| median | 41809 |
| Q3 | 43973 |
| 95-th percentile | 45831.8 |
| Maximum | 51550 |
| Range | 12940 |
| Interquartile range (IQR) | 4490 |
Descriptive statistics
| Standard deviation | 2610.191793 |
|---|---|
| Coefficient of variation (CV) | 0.06230066807 |
| Kurtosis | 0.4311734026 |
| Mean | 41896.69027 |
| Median Absolute Deviation (MAD) | 2292 |
| Skewness | 0.7338080619 |
| Sum | 4734326 |
| Variance | 6813101.198 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 41883 | 2 | 1.7% | |
| 45555 | 1 | 0.8% | |
| 44208 | 1 | 0.8% | |
| 38674 | 1 | 0.8% | |
| 39030 | 1 | 0.8% | |
| 45495 | 1 | 0.8% | |
| 44709 | 1 | 0.8% | |
| 44612 | 1 | 0.8% | |
| 41809 | 1 | 0.8% | |
| 42060 | 1 | 0.8% | |
| Other values (102) | 102 | 85.0% | |
| (Missing) | 7 | 5.8% |
| Value | Count | Frequency (%) | |
| 38610 | 1 | 0.8% | |
| 38672 | 1 | 0.8% | |
| 38674 | 1 | 0.8% | |
| 38687 | 1 | 0.8% | |
| 38702 | 1 | 0.8% |
| Value | Count | Frequency (%) | |
| 51550 | 1 | 0.8% | |
| 48971 | 1 | 0.8% | |
| 46252 | 1 | 0.8% | |
| 46061 | 1 | 0.8% | |
| 45919 | 1 | 0.8% |
| Distinct | 114 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 6 |
| Missing (%) | 5.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22234394.59 |
|---|---|
| Minimum | 12133564 |
| Maximum | 42564371.19 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 960.0 B |
Quantile statistics
| Minimum | 12133564 |
|---|---|
| 5-th percentile | 13968653.2 |
| Q1 | 17869948.5 |
| median | 22323412.86 |
| Q3 | 24861131.86 |
| 95-th percentile | 31582916.99 |
| Maximum | 42564371.19 |
| Range | 30430807.19 |
| Interquartile range (IQR) | 6991183.358 |
Descriptive statistics
| Standard deviation | 5522404.148 |
|---|---|
| Coefficient of variation (CV) | 0.2483721392 |
| Kurtosis | 1.085323037 |
| Mean | 22234394.59 |
| Median Absolute Deviation (MAD) | 3675766.86 |
| Skewness | 0.7162443776 |
| Sum | 2534720983 |
| Variance | 3.049694757e+13 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 17205564 | 1 | 0.8% | |
| 16520393 | 1 | 0.8% | |
| 21678526 | 1 | 0.8% | |
| 16532801 | 1 | 0.8% | |
| 23948006 | 1 | 0.8% | |
| 20081886.69 | 1 | 0.8% | |
| 42564371.19 | 1 | 0.8% | |
| 30201308.33 | 1 | 0.8% | |
| 16303602 | 1 | 0.8% | |
| 16311822 | 1 | 0.8% | |
| Other values (104) | 104 | 86.7% | |
| (Missing) | 6 | 5.0% |
| Value | Count | Frequency (%) | |
| 12133564 | 1 | 0.8% | |
| 12260429 | 1 | 0.8% | |
| 12512194 | 1 | 0.8% | |
| 13175593 | 1 | 0.8% | |
| 13381592 | 1 | 0.8% |
| Value | Count | Frequency (%) | |
| 42564371.19 | 1 | 0.8% | |
| 37589445.29 | 1 | 0.8% | |
| 35364843.8 | 1 | 0.8% | |
| 34524711.89 | 1 | 0.8% | |
| 32516686.26 | 1 | 0.8% |
| Distinct | 114 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 6 |
| Missing (%) | 5.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.644355497 |
|---|---|
| Minimum | 2.219204819 |
| Maximum | 2.973794947 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 960.0 B |
Quantile statistics
| Minimum | 2.219204819 |
|---|---|
| 5-th percentile | 2.279166904 |
| Q1 | 2.593145863 |
| median | 2.696189556 |
| Q3 | 2.769318685 |
| 95-th percentile | 2.851153875 |
| Maximum | 2.973794947 |
| Range | 0.754590128 |
| Interquartile range (IQR) | 0.1761728215 |
Descriptive statistics
| Standard deviation | 0.1767973237 |
|---|---|
| Coefficient of variation (CV) | 0.06685837962 |
| Kurtosis | 0.1034454822 |
| Mean | 2.644355497 |
| Median Absolute Deviation (MAD) | 0.07740988441 |
| Skewness | -0.9387608251 |
| Sum | 301.4565267 |
| Variance | 0.03125729366 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 2.593731291 | 1 | 0.8% | |
| 2.86650551 | 1 | 0.8% | |
| 2.244096849 | 1 | 0.8% | |
| 2.800892484 | 1 | 0.8% | |
| 2.575514219 | 1 | 0.8% | |
| 2.574276556 | 1 | 0.8% | |
| 2.741036431 | 1 | 0.8% | |
| 2.301483185 | 1 | 0.8% | |
| 2.837050243 | 1 | 0.8% | |
| 2.380881576 | 1 | 0.8% | |
| Other values (104) | 104 | 86.7% | |
| (Missing) | 6 | 5.0% |
| Value | Count | Frequency (%) | |
| 2.219204819 | 1 | 0.8% | |
| 2.232548631 | 1 | 0.8% | |
| 2.239366741 | 1 | 0.8% | |
| 2.243491418 | 1 | 0.8% | |
| 2.244096849 | 1 | 0.8% |
| Value | Count | Frequency (%) | |
| 2.973794947 | 1 | 0.8% | |
| 2.962782847 | 1 | 0.8% | |
| 2.869254596 | 1 | 0.8% | |
| 2.86650551 | 1 | 0.8% | |
| 2.863090196 | 1 | 0.8% |
| Distinct | 114 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 6 |
| Missing (%) | 5.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 42919868.72 |
|---|---|
| Minimum | 33057754.56 |
| Maximum | 61182491 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 960.0 B |
Quantile statistics
| Minimum | 33057754.56 |
|---|---|
| 5-th percentile | 33954645.4 |
| Q1 | 37457299.8 |
| median | 42427490.45 |
| Q3 | 47081639.28 |
| 95-th percentile | 56583288 |
| Maximum | 61182491 |
| Range | 28124736.44 |
| Interquartile range (IQR) | 9624339.473 |
Descriptive statistics
| Standard deviation | 6778457.369 |
|---|---|
| Coefficient of variation (CV) | 0.1579328542 |
| Kurtosis | 0.04633351701 |
| Mean | 42919868.72 |
| Median Absolute Deviation (MAD) | 4928626.07 |
| Skewness | 0.7365346295 |
| Sum | 4892865034 |
| Variance | 4.59474843e+13 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 47680571.77 | 1 | 0.8% | |
| 35752242.66 | 1 | 0.8% | |
| 38541215.98 | 1 | 0.8% | |
| 56994413 | 1 | 0.8% | |
| 39073280.52 | 1 | 0.8% | |
| 61182491 | 1 | 0.8% | |
| 44978767 | 1 | 0.8% | |
| 60101330 | 1 | 0.8% | |
| 34640686 | 1 | 0.8% | |
| 49550968.57 | 1 | 0.8% | |
| Other values (104) | 104 | 86.7% | |
| (Missing) | 6 | 5.0% |
| Value | Count | Frequency (%) | |
| 33057754.56 | 1 | 0.8% | |
| 33230430.2 | 1 | 0.8% | |
| 33373634.68 | 1 | 0.8% | |
| 33751611.71 | 1 | 0.8% | |
| 33833875.1 | 1 | 0.8% |
| Value | Count | Frequency (%) | |
| 61182491 | 1 | 0.8% | |
| 60101330 | 1 | 0.8% | |
| 60086742 | 1 | 0.8% | |
| 59542020 | 1 | 0.8% | |
| 58861253 | 1 | 0.8% |
| Distinct | 103 |
|---|---|
| Distinct (%) | 90.4% |
| Missing | 6 |
| Missing (%) | 5.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.939969407 |
|---|---|
| Minimum | 1.12 |
| Maximum | 2.519452521 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 960.0 B |
Quantile statistics
| Minimum | 1.12 |
|---|---|
| 5-th percentile | 1.2895 |
| Q1 | 1.824167969 |
| median | 1.999121092 |
| Q3 | 2.153538771 |
| 95-th percentile | 2.329268701 |
| Maximum | 2.519452521 |
| Range | 1.399452521 |
| Interquartile range (IQR) | 0.3293708018 |
Descriptive statistics
| Standard deviation | 0.3069138849 |
|---|---|
| Coefficient of variation (CV) | 0.1582055283 |
| Kurtosis | 0.383213076 |
| Mean | 1.939969407 |
| Median Absolute Deviation (MAD) | 0.166819735 |
| Skewness | -0.8157250488 |
| Sum | 221.1565124 |
| Variance | 0.09419613274 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 2 | 3 | 2.5% | |
| 1.74 | 3 | 2.5% | |
| 1.55 | 2 | 1.7% | |
| 1.53 | 2 | 1.7% | |
| 1.59 | 2 | 1.7% | |
| 1.86 | 2 | 1.7% | |
| 1.14 | 2 | 1.7% | |
| 1.83 | 2 | 1.7% | |
| 2.19 | 2 | 1.7% | |
| 1.956590489 | 1 | 0.8% | |
| Other values (93) | 93 | 77.5% | |
| (Missing) | 6 | 5.0% |
| Value | Count | Frequency (%) | |
| 1.12 | 1 | 0.8% | |
| 1.14 | 2 | 1.7% | |
| 1.22 | 1 | 0.8% | |
| 1.24 | 1 | 0.8% | |
| 1.27 | 1 | 0.8% |
| Value | Count | Frequency (%) | |
| 2.519452521 | 1 | 0.8% | |
| 2.514430105 | 1 | 0.8% | |
| 2.450889913 | 1 | 0.8% | |
| 2.414168033 | 1 | 0.8% | |
| 2.399608712 | 1 | 0.8% |
| Distinct | 114 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 6 |
| Missing (%) | 5.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 175339.502 |
|---|---|
| Minimum | 126984 |
| Maximum | 245847 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 960.0 B |
Quantile statistics
| Minimum | 126984 |
|---|---|
| 5-th percentile | 141937.4043 |
| Q1 | 156059.5059 |
| median | 168361 |
| Q3 | 191042.2229 |
| 95-th percentile | 225402.3 |
| Maximum | 245847 |
| Range | 118863 |
| Interquartile range (IQR) | 34982.71703 |
Descriptive statistics
| Standard deviation | 26253.99238 |
|---|---|
| Coefficient of variation (CV) | 0.1497323312 |
| Kurtosis | -0.1603192917 |
| Mean | 175339.502 |
| Median Absolute Deviation (MAD) | 16013.84834 |
| Skewness | 0.7033810335 |
| Sum | 19988703.23 |
| Variance | 689272116 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 165849.7887 | 1 | 0.8% | |
| 191138.9639 | 1 | 0.8% | |
| 168104 | 1 | 0.8% | |
| 170451 | 1 | 0.8% | |
| 169646 | 1 | 0.8% | |
| 160260.087 | 1 | 0.8% | |
| 143450.1913 | 1 | 0.8% | |
| 180308.201 | 1 | 0.8% | |
| 197061 | 1 | 0.8% | |
| 163134.5925 | 1 | 0.8% | |
| Other values (104) | 104 | 86.7% | |
| (Missing) | 6 | 5.0% |
| Value | Count | Frequency (%) | |
| 126984 | 1 | 0.8% | |
| 130737 | 1 | 0.8% | |
| 137986.5653 | 1 | 0.8% | |
| 139587 | 1 | 0.8% | |
| 140219.2261 | 1 | 0.8% |
| Value | Count | Frequency (%) | |
| 245847 | 1 | 0.8% | |
| 240286 | 1 | 0.8% | |
| 237568 | 1 | 0.8% | |
| 230033 | 1 | 0.8% | |
| 228345 | 1 | 0.8% |
| Distinct | 49 |
|---|---|
| Distinct (%) | 43.0% |
| Missing | 6 |
| Missing (%) | 5.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.05981578947 |
|---|---|
| Minimum | 0.035 |
| Maximum | 0.147 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 960.0 B |
Quantile statistics
| Minimum | 0.035 |
|---|---|
| 5-th percentile | 0.036 |
| Q1 | 0.04125 |
| median | 0.053 |
| Q3 | 0.07675 |
| 95-th percentile | 0.09035 |
| Maximum | 0.147 |
| Range | 0.112 |
| Interquartile range (IQR) | 0.0355 |
Descriptive statistics
| Standard deviation | 0.02154664247 |
|---|---|
| Coefficient of variation (CV) | 0.360216636 |
| Kurtosis | 1.832807721 |
| Mean | 0.05981578947 |
| Median Absolute Deviation (MAD) | 0.014 |
| Skewness | 1.157649941 |
| Sum | 6.819 |
| Variance | 0.0004642578016 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=49)
| Value | Count | Frequency (%) | |
| 0.041 | 6 | 5.0% | |
| 0.09 | 6 | 5.0% | |
| 0.049 | 6 | 5.0% | |
| 0.05 | 6 | 5.0% | |
| 0.082 | 5 | 4.2% | |
| 0.037 | 5 | 4.2% | |
| 0.038 | 4 | 3.3% | |
| 0.044 | 4 | 3.3% | |
| 0.036 | 4 | 3.3% | |
| 0.039 | 4 | 3.3% | |
| Other values (39) | 64 | 53.3% | |
| (Missing) | 6 | 5.0% |
| Value | Count | Frequency (%) | |
| 0.035 | 4 | 3.3% | |
| 0.036 | 4 | 3.3% | |
| 0.037 | 5 | 4.2% | |
| 0.038 | 4 | 3.3% | |
| 0.039 | 4 | 3.3% |
| Value | Count | Frequency (%) | |
| 0.147 | 1 | 0.8% | |
| 0.133 | 1 | 0.8% | |
| 0.111 | 1 | 0.8% | |
| 0.092 | 1 | 0.8% | |
| 0.091 | 2 | 1.7% |
| Distinct | 114 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 6 |
| Missing (%) | 5.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1423974.819 |
|---|---|
| Minimum | 978249.75 |
| Maximum | 1627768 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 960.0 B |
Quantile statistics
| Minimum | 978249.75 |
|---|---|
| 5-th percentile | 1282335.6 |
| Q1 | 1390127.4 |
| median | 1426168.125 |
| Q3 | 1487755.688 |
| 95-th percentile | 1519096.85 |
| Maximum | 1627768 |
| Range | 649518.25 |
| Interquartile range (IQR) | 97628.2875 |
Descriptive statistics
| Standard deviation | 89635.9387 |
|---|---|
| Coefficient of variation (CV) | 0.06294769929 |
| Kurtosis | 5.865385513 |
| Mean | 1423974.819 |
| Median Absolute Deviation (MAD) | 48753.8 |
| Skewness | -1.532676047 |
| Sum | 162333129.3 |
| Variance | 8034601506 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 1456126 | 1 | 0.8% | |
| 1458816.5 | 1 | 0.8% | |
| 1621642 | 1 | 0.8% | |
| 1489978 | 1 | 0.8% | |
| 1387615.4 | 1 | 0.8% | |
| 1368218.5 | 1 | 0.8% | |
| 1498006.6 | 1 | 0.8% | |
| 1450302.8 | 1 | 0.8% | |
| 1482931 | 1 | 0.8% | |
| 1490612.75 | 1 | 0.8% | |
| Other values (104) | 104 | 86.7% | |
| (Missing) | 6 | 5.0% |
| Value | Count | Frequency (%) | |
| 978249.75 | 1 | 0.8% | |
| 1152506 | 1 | 0.8% | |
| 1157706.4 | 1 | 0.8% | |
| 1191209 | 1 | 0.8% | |
| 1222698 | 1 | 0.8% |
| Value | Count | Frequency (%) | |
| 1627768 | 1 | 0.8% | |
| 1621642 | 1 | 0.8% | |
| 1599578 | 1 | 0.8% | |
| 1579452 | 1 | 0.8% | |
| 1522903 | 1 | 0.8% |
| Distinct | 113 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 7 |
| Missing (%) | 5.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 321065.5964 |
|---|---|
| Minimum | 311023 |
| Maximum | 329894 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 960.0 B |
Quantile statistics
| Minimum | 311023 |
|---|---|
| 5-th percentile | 311995 |
| Q1 | 316016 |
| median | 321428 |
| Q3 | 326216 |
| 95-th percentile | 329240.2 |
| Maximum | 329894 |
| Range | 18871 |
| Interquartile range (IQR) | 10200 |
Descriptive statistics
| Standard deviation | 5701.335086 |
|---|---|
| Coefficient of variation (CV) | 0.01775753974 |
| Kurtosis | -1.270420718 |
| Mean | 321065.5964 |
| Median Absolute Deviation (MAD) | 5023 |
| Skewness | -0.1368641876 |
| Sum | 36280412.39 |
| Variance | 32505221.76 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 313883 | 1 | 0.8% | |
| 319904 | 1 | 0.8% | |
| 318692 | 1 | 0.8% | |
| 315682 | 1 | 0.8% | |
| 326563 | 1 | 0.8% | |
| 320053 | 1 | 0.8% | |
| 323876 | 1 | 0.8% | |
| 329760 | 1 | 0.8% | |
| 311333 | 1 | 0.8% | |
| 328140 | 1 | 0.8% | |
| Other values (103) | 103 | 85.8% | |
| (Missing) | 7 | 5.8% |
| Value | Count | Frequency (%) | |
| 311023 | 1 | 0.8% | |
| 311173 | 1 | 0.8% | |
| 311333 | 1 | 0.8% | |
| 311502 | 1 | 0.8% | |
| 311678 | 1 | 0.8% |
| Value | Count | Frequency (%) | |
| 329894 | 1 | 0.8% | |
| 329760 | 1 | 0.8% | |
| 329673.3894 | 1 | 0.8% | |
| 329527 | 1 | 0.8% | |
| 329423 | 1 | 0.8% |
| Distinct | 108 |
|---|---|
| Distinct (%) | 93.9% |
| Missing | 5 |
| Missing (%) | 4.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.491407826 |
|---|---|
| Minimum | 0.6745 |
| Maximum | 2.1575 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 960.0 B |
Quantile statistics
| Minimum | 0.6745 |
|---|---|
| 5-th percentile | 0.86814 |
| Q1 | 1.3452 |
| median | 1.5255 |
| Q3 | 1.71395 |
| 95-th percentile | 1.90665 |
| Maximum | 2.1575 |
| Range | 1.483 |
| Interquartile range (IQR) | 0.36875 |
Descriptive statistics
| Standard deviation | 0.3118347904 |
|---|---|
| Coefficient of variation (CV) | 0.2090875379 |
| Kurtosis | 0.2363902023 |
| Mean | 1.491407826 |
| Median Absolute Deviation (MAD) | 0.1835 |
| Skewness | -0.6531093502 |
| Sum | 171.5119 |
| Variance | 0.09724093652 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 1.76 | 4 | 3.3% | |
| 1.4836 | 2 | 1.7% | |
| 1.57 | 2 | 1.7% | |
| 1.745 | 2 | 1.7% | |
| 1.709 | 2 | 1.7% | |
| 1.43 | 1 | 0.8% | |
| 1.8333 | 1 | 0.8% | |
| 1.08 | 1 | 0.8% | |
| 1.079 | 1 | 0.8% | |
| 1.5324 | 1 | 0.8% | |
| Other values (98) | 98 | 81.7% | |
| (Missing) | 5 | 4.2% |
| Value | Count | Frequency (%) | |
| 0.6745 | 1 | 0.8% | |
| 0.6926 | 1 | 0.8% | |
| 0.6981 | 1 | 0.8% | |
| 0.7705 | 1 | 0.8% | |
| 0.79 | 1 | 0.8% |
| Value | Count | Frequency (%) | |
| 2.1575 | 1 | 0.8% | |
| 2.0883 | 1 | 0.8% | |
| 2.025 | 1 | 0.8% | |
| 2.02 | 1 | 0.8% | |
| 2.0191 | 1 | 0.8% |
| Distinct | 12 |
|---|---|
| Distinct (%) | 10.5% |
| Missing | 6 |
| Missing (%) | 5.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 658509.2451 |
|---|---|
| Minimum | 642650.4469 |
| Maximum | 664621 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 960.0 B |
Quantile statistics
| Minimum | 642650.4469 |
|---|---|
| 5-th percentile | 642650.4469 |
| Q1 | 649719.6018 |
| median | 662389 |
| Q3 | 662982 |
| 95-th percentile | 664621 |
| Maximum | 664621 |
| Range | 21970.55313 |
| Interquartile range (IQR) | 13262.39821 |
Descriptive statistics
| Standard deviation | 7309.740559 |
|---|---|
| Coefficient of variation (CV) | 0.01110043726 |
| Kurtosis | -0.4622901543 |
| Mean | 658509.2451 |
| Median Absolute Deviation (MAD) | 1804 |
| Skewness | -1.11259197 |
| Sum | 75070053.94 |
| Variance | 53432307.03 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) | |
| 662389 | 12 | 10.0% | |
| 647149 | 12 | 10.0% | |
| 662236 | 12 | 10.0% | |
| 662982 | 12 | 10.0% | |
| 664621 | 12 | 10.0% | |
| 660004 | 12 | 10.0% | |
| 662679 | 12 | 10.0% | |
| 664193 | 12 | 10.0% | |
| 649719.6018 | 8 | 6.7% | |
| 642650.4469 | 6 | 5.0% | |
| Other values (2) | 4 | 3.3% | |
| (Missing) | 6 | 5.0% |
| Value | Count | Frequency (%) | |
| 642650.4469 | 6 | 5.0% | |
| 642650.4469 | 1 | 0.8% | |
| 646236 | 3 | 2.5% | |
| 647149 | 12 | 10.0% | |
| 649719.6018 | 8 | 6.7% |
| Value | Count | Frequency (%) | |
| 664621 | 12 | 10.0% | |
| 664193 | 12 | 10.0% | |
| 662982 | 12 | 10.0% | |
| 662679 | 12 | 10.0% | |
| 662389 | 12 | 10.0% |
| Distinct | 114 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 6 |
| Missing (%) | 5.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 82332.91274 |
|---|---|
| Minimum | 66810.10817 |
| Maximum | 104885 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 960.0 B |
Quantile statistics
| Minimum | 66810.10817 |
|---|---|
| 5-th percentile | 68559.95 |
| Q1 | 74806 |
| median | 80177.54722 |
| Q3 | 89828.7083 |
| 95-th percentile | 100069.1 |
| Maximum | 104885 |
| Range | 38074.89183 |
| Interquartile range (IQR) | 15022.7083 |
Descriptive statistics
| Standard deviation | 9880.760959 |
|---|---|
| Coefficient of variation (CV) | 0.1200098555 |
| Kurtosis | -0.7179524718 |
| Mean | 82332.91274 |
| Median Absolute Deviation (MAD) | 6538 |
| Skewness | 0.5012647841 |
| Sum | 9385952.053 |
| Variance | 97629437.13 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 100723 | 1 | 0.8% | |
| 80332 | 1 | 0.8% | |
| 85065 | 1 | 0.8% | |
| 84595 | 1 | 0.8% | |
| 84462 | 1 | 0.8% | |
| 101642 | 1 | 0.8% | |
| 94010.91632 | 1 | 0.8% | |
| 95419 | 1 | 0.8% | |
| 93094 | 1 | 0.8% | |
| 79883 | 1 | 0.8% | |
| Other values (104) | 104 | 86.7% | |
| (Missing) | 6 | 5.0% |
| Value | Count | Frequency (%) | |
| 66810.10817 | 1 | 0.8% | |
| 67422.74733 | 1 | 0.8% | |
| 67711 | 1 | 0.8% | |
| 67939 | 1 | 0.8% | |
| 67942 | 1 | 0.8% |
| Value | Count | Frequency (%) | |
| 104885 | 1 | 0.8% | |
| 104835 | 1 | 0.8% | |
| 102868 | 1 | 0.8% | |
| 101774 | 1 | 0.8% | |
| 101642 | 1 | 0.8% |
| Distinct | 25 |
|---|---|
| Distinct (%) | 21.9% |
| Missing | 6 |
| Missing (%) | 5.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 58107.32557 |
|---|---|
| Minimum | 55795.19294 |
| Maximum | 60572.09836 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 960.0 B |
Quantile statistics
| Minimum | 55795.19294 |
|---|---|
| 5-th percentile | 55795.19294 |
| Q1 | 57445.922 |
| median | 57942.46206 |
| Q3 | 58994.621 |
| 95-th percentile | 60572.09836 |
| Maximum | 60572.09836 |
| Range | 4776.90542 |
| Interquartile range (IQR) | 1548.699 |
Descriptive statistics
| Standard deviation | 1294.731269 |
|---|---|
| Coefficient of variation (CV) | 0.0222817219 |
| Kurtosis | -0.2708559373 |
| Mean | 58107.32557 |
| Median Absolute Deviation (MAD) | 877.69106 |
| Skewness | 0.1654232913 |
| Sum | 6624235.115 |
| Variance | 1676329.059 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=25)
| Value | Count | Frequency (%) | |
| 55795.19294 | 12 | 10.0% | |
| 59357.81536 | 12 | 10.0% | |
| 60572.09836 | 12 | 10.0% | |
| 57942.46206 | 12 | 10.0% | |
| 56968.28926 | 7 | 5.8% | |
| 57601.938 | 3 | 2.5% | |
| 58098.972 | 3 | 2.5% | |
| 57445.922 | 3 | 2.5% | |
| 58131.044 | 3 | 2.5% | |
| 58735.604 | 3 | 2.5% | |
| Other values (15) | 44 | 36.7% | |
| (Missing) | 6 | 5.0% |
| Value | Count | Frequency (%) | |
| 55795.19294 | 12 | 10.0% | |
| 56968.28926 | 2 | 1.7% | |
| 56968.28926 | 7 | 5.8% | |
| 56982.691 | 3 | 2.5% | |
| 57146.851 | 3 | 2.5% |
| Value | Count | Frequency (%) | |
| 60572.09836 | 12 | 10.0% | |
| 59357.81536 | 12 | 10.0% | |
| 59083.653 | 3 | 2.5% | |
| 58994.621 | 3 | 2.5% | |
| 58985.815 | 3 | 2.5% |
| Distinct | 112 |
|---|---|
| Distinct (%) | 98.2% |
| Missing | 6 |
| Missing (%) | 5.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3010.937065 |
|---|---|
| Minimum | 602.75 |
| Maximum | 7535.75 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 960.0 B |
Quantile statistics
| Minimum | 602.75 |
|---|---|
| 5-th percentile | 1511.375 |
| Q1 | 2253.775 |
| median | 2838.9 |
| Q3 | 3712.9375 |
| 95-th percentile | 4823.6325 |
| Maximum | 7535.75 |
| Range | 6933 |
| Interquartile range (IQR) | 1459.1625 |
Descriptive statistics
| Standard deviation | 1143.321201 |
|---|---|
| Coefficient of variation (CV) | 0.3797227163 |
| Kurtosis | 1.257162946 |
| Mean | 3010.937065 |
| Median Absolute Deviation (MAD) | 696.375 |
| Skewness | 0.7321398184 |
| Sum | 343246.8254 |
| Variance | 1307183.368 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 3418 | 2 | 1.7% | |
| 2530 | 2 | 1.7% | |
| 3441.75 | 1 | 0.8% | |
| 2673.2 | 1 | 0.8% | |
| 4181.75 | 1 | 0.8% | |
| 2725.25 | 1 | 0.8% | |
| 1682.5 | 1 | 0.8% | |
| 3926 | 1 | 0.8% | |
| 2375 | 1 | 0.8% | |
| 3590 | 1 | 0.8% | |
| Other values (102) | 102 | 85.0% | |
| (Missing) | 6 | 5.0% |
| Value | Count | Frequency (%) | |
| 602.75 | 1 | 0.8% | |
| 791 | 1 | 0.8% | |
| 1210.75 | 1 | 0.8% | |
| 1222.5 | 1 | 0.8% | |
| 1275 | 1 | 0.8% |
| Value | Count | Frequency (%) | |
| 7535.75 | 1 | 0.8% | |
| 5582.5 | 1 | 0.8% | |
| 5539.25 | 1 | 0.8% | |
| 5418 | 1 | 0.8% | |
| 5212.5 | 1 | 0.8% |
| Distinct | 115 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 5 |
| Missing (%) | 4.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 67179579.67 |
|---|---|
| Minimum | 91662.5 |
| Maximum | 104951000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 960.0 B |
Quantile statistics
| Minimum | 91662.5 |
|---|---|
| 5-th percentile | 41159800 |
| Q1 | 58684500 |
| median | 66719000 |
| Q3 | 77643000 |
| 95-th percentile | 97353400 |
| Maximum | 104951000 |
| Range | 104859337.5 |
| Interquartile range (IQR) | 18958500 |
Descriptive statistics
| Standard deviation | 17133947.67 |
|---|---|
| Coefficient of variation (CV) | 0.2550469615 |
| Kurtosis | 1.254069509 |
| Mean | 67179579.67 |
| Median Absolute Deviation (MAD) | 10110000 |
| Skewness | -0.3076955652 |
| Sum | 7725651662 |
| Variance | 2.935721628e+14 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 102772000 | 1 | 0.8% | |
| 71639000 | 1 | 0.8% | |
| 41194000 | 1 | 0.8% | |
| 79955000 | 1 | 0.8% | |
| 36197000 | 1 | 0.8% | |
| 77032000 | 1 | 0.8% | |
| 69462000 | 1 | 0.8% | |
| 81993000 | 1 | 0.8% | |
| 86813000 | 1 | 0.8% | |
| 41080000 | 1 | 0.8% | |
| Other values (105) | 105 | 87.5% | |
| (Missing) | 5 | 4.2% |
| Value | Count | Frequency (%) | |
| 91662.5 | 1 | 0.8% | |
| 33183000 | 1 | 0.8% | |
| 33732000 | 1 | 0.8% | |
| 35657000 | 1 | 0.8% | |
| 36197000 | 1 | 0.8% |
| Value | Count | Frequency (%) | |
| 104951000 | 1 | 0.8% | |
| 102772000 | 1 | 0.8% | |
| 101564000 | 1 | 0.8% | |
| 98708000 | 1 | 0.8% | |
| 97745000 | 1 | 0.8% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| Years | Time Series | RDPI | Retail Fresh Wing Sales | Retail Fresh Wing Price | Comm FS Wing Sales | Comm FS Wing Price | FS Nuggets Servings | Unemployment | Traffic | Pop | Wings_P | Operator Count | Wing Servings | Retail Store Count | Retail Wing Promotion | Wing Inventory | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2011.0 | 2011-01-01 | 38826.0 | 13911084.0 | 2.292848 | 3.660115e+07 | 1.31 | 143806.189774 | 0.092 | 1478322.0 | 311023.0 | 0.9181 | 649719.601787 | 83004.728612 | 55795.19294 | 1517.5 | 66045000.0 |
| 1 | 2011.0 | 2011-02-01 | 38903.0 | 15248423.0 | 2.300764 | 3.397114e+07 | 1.22 | 142981.799634 | 0.090 | 1522705.0 | 311173.0 | 0.7705 | 649719.601787 | 80581.050225 | 55795.19294 | 1790.0 | 71010000.0 |
| 2 | 2011.0 | 2011-03-01 | 38764.0 | 16532801.0 | 2.243491 | 4.333886e+07 | 1.14 | 191222.669422 | 0.090 | 1263041.0 | 311333.0 | 0.6926 | 649719.601787 | 90943.086312 | 55795.19294 | 1570.0 | 67778000.0 |
| 3 | 2011.0 | 2011-04-01 | 38672.0 | 13175593.0 | 2.239367 | 3.375161e+07 | 1.12 | 155780.674521 | 0.091 | 1579452.0 | 311502.0 | 0.6745 | 649719.601787 | 79294.600664 | 55795.19294 | 1682.5 | 69045000.0 |
| 4 | 2011.0 | 2011-05-01 | 38610.0 | 14373178.0 | 2.219205 | 3.392401e+07 | 1.14 | 151707.160375 | 0.090 | 1599578.0 | 311678.0 | 0.6981 | 649719.601787 | 72620.448440 | 55795.19294 | 2196.0 | 65801000.0 |
| 5 | NaN | 2011-06-01 | 38766.0 | 17205564.0 | 2.253759 | 4.259801e+07 | 1.24 | 205333.206177 | 0.091 | 1292725.0 | 311872.0 | 0.7900 | 649719.601787 | 96898.013133 | 55795.19294 | 2667.5 | 69410000.0 |
| 6 | NaN | 2011-07-01 | 38854.0 | 12260429.0 | 2.327112 | 3.403503e+07 | 1.27 | 160260.086986 | 0.090 | 1627768.0 | 312077.0 | 0.8435 | 649719.601787 | 77215.705588 | 55795.19294 | 1787.5 | 72477000.0 |
| 7 | NaN | 2011-08-01 | 38785.0 | 12512194.0 | 2.301483 | 3.492238e+07 | 1.30 | 165606.513757 | 0.090 | 1621642.0 | 312292.0 | 0.8787 | 649719.601787 | 80023.094435 | 55795.19294 | 2674.0 | 62412000.0 |
| 8 | NaN | 2011-09-01 | 38687.0 | 17281550.0 | 2.232549 | 4.364277e+07 | 1.41 | 199929.624273 | 0.090 | 1222698.0 | 312509.0 | 1.0176 | 642650.446872 | 91303.625850 | 55795.19294 | 2530.0 | 51240000.0 |
| 9 | NaN | 2011-10-01 | 38732.0 | 13381592.0 | 2.244097 | 3.517219e+07 | 1.53 | 152141.151894 | 0.088 | 1517154.0 | 312708.0 | 1.1057 | 642650.446872 | 67422.747333 | 55795.19294 | 2367.5 | 51019000.0 |
Last rows
| Years | Time Series | RDPI | Retail Fresh Wing Sales | Retail Fresh Wing Price | Comm FS Wing Sales | Comm FS Wing Price | FS Nuggets Servings | Unemployment | Traffic | Pop | Wings_P | Operator Count | Wing Servings | Retail Store Count | Retail Wing Promotion | Wing Inventory | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 110 | 2020.0 | 2020-03-01 | 45381.0 | 3.452471e+07 | 2.866506 | 46098821.0 | 2.052753 | 183428.0 | 0.044 | 1157706.40 | 329673.389443 | 1.5255 | 662236.0 | 84056.0 | 57955.540 | 2398.60 | 53678000.0 |
| 111 | 2020.0 | 2020-04-01 | 51550.0 | 4.256437e+07 | 2.822043 | 34640686.0 | 1.666673 | 156896.0 | 0.147 | 978249.75 | 329760.000000 | 1.0233 | 646236.0 | 68887.0 | 58098.972 | 602.75 | 53413000.0 |
| 112 | 2020.0 | 2020-05-01 | 48971.0 | 3.037545e+07 | 2.962783 | 42856623.0 | 1.937144 | 190752.0 | 0.133 | 1152506.00 | 329894.000000 | 1.4860 | 646236.0 | 76169.0 | 58098.972 | 791.00 | 51723000.0 |
| 113 | NaN | 2020-06-01 | NaN | 2.928170e+07 | 2.973795 | 59542020.0 | 2.095691 | 245847.0 | 0.111 | 1293264.00 | NaN | 1.5059 | 646236.0 | 104885.0 | 58098.972 | 1734.40 | 53888000.0 |
| 114 | NaN | NaT | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1.6218 | NaN | NaN | NaN | NaN | 91662.5 |
| 115 | NaN | NaT | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 116 | NaN | NaT | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 117 | NaN | NaT | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 118 | NaN | NaT | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 119 | NaN | NaT | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |